package safari.model.faq;

import java.sql.SQLException;
import java.util.List;

public interface FAQDao {
	public  void insertBoard(FAQBoardVO fvo) throws SQLException;
	public void deleteBoard(int no) throws SQLException;
	public  void updateBoard(FAQBoardVO fvo) throws SQLException;
	public int updateHits(int no) throws SQLException;
	public FAQBoardVO selectBoardByNo(int no) throws SQLException;
	public List<FAQBoardVO> selectAllBoard() throws SQLException;
	public int getTotalContents() throws SQLException;
	public int getTotalContentsByTitleOrContent(String keyword) throws SQLException;
	public int getTotalContentsByTitle(String title) throws SQLException;
	public int getTotalContentsByContent(String content) throws SQLException;
	public int getTotalContentsByCategory(String category) throws SQLException;
	public List<FAQBoardVO> selectBoardByTitle(String title) throws SQLException;
	public List<FAQBoardVO> selectBoardByContent(String content) throws SQLException;
	public List<FAQBoardVO> selectBoardByTitleOrContent(String keyword) throws SQLException;
	public int getHitsByNo(int no) throws SQLException;
	public List<FAQBoardVO> selectBoardByCategory(String category) throws SQLException;
}
